1. Problem Statement
2. About the dataset
3. Output
3.1 Institution Analysis in 2021
3.2 Comparative Analysis
4. Conclusion
5. References
New York State Education Department is an entity that looks over the supervision of all public schools in New York. They are also the entity that is responsible for ensuring standardizing testing as well as the production and administration of state tests and Regents Examinations.
GRAD_RATE_AND_OUTCOMES_2021 gives us information regarding the graduation and dropout data for the state of New York, as well as for the counties necessary to interpret certain downfalls within the system in specific locations post analyzing the correlations between the economically disabled, students suffering from a disability, non-English speaking students and migrant student vs the graduation percentage and the drop rate to deduce necessary inferences and take actions for continuous improvement in the year of 2022 based on performance index of 2021.
The analysis conducted are: - Enrollment Comparison by County - School Comparison by highest enrollment - County Average by Education Score - English vs Non-English Speakers enrollment in different cohorts on a statewide level - Migrant enrollments in different counties in the years 2020 & 2021 - Race Wise Comparisons – Dropout Rate v Graduation Rate - Comparison of graduation and dropout rate for Economically v Non-Economically challenged sections of the population - Parameter comparison of Disabled students and All students - Male v Female enrollment comparison done across the state of New York
GRAD_RATE_AND_OUTCOMES_2021: The variables available for analysis are: - Aggregation_Index - Aggregation_Type - Aggregation_Name - Membership_Desc - Subgroup_Name - Enroll_Cnt - Grad_Cnt - Grad_Pct - Dropout_Cnt - Dropout_Pct - ged_pct - non-diploma_credential_pct - regent_pct - regent_adv_pct - local_pct
This database contains annual graduation, and dropout data for the state as well as by county, Need to Resource Capacity group, district, public school, and charter school. Annual graduation data is included for the current four-year cohort (June and August graduates), five-year June and August, and six-year June and August cohorts.
Referred from Graduation Rate Database: (https://data.nysed.gov/downloads.php)
The number of enrollments helps us confirm the population index of New York Demographic and ascertain the level of education of the populous in the year 2021.
Post analysis it can be observed that the enrollment is high in Kings County accompanied by Queens County, Suffolk County, and Nassau County among others; matching the New York population index by county inferencing, the counties having the highest population are among the counties having highest enrollment too.
A deeper analysis is conducted to confirm the above inference; In this analysis, the enrollments are computed with respect to schools in the entire state. A regular bar plot is plotted to understand the comparison.
The plot shows Brentwood High School, Suffolk having the highest enrollment in the year 2021 followed by Brooklyn Technical High School, Kings, Fort Hamilton High School, Kings, and Francis Lewis High School, Queens. The counties having the highest population consist of the schools having the highest population hence bolstering the support for the inference.
A metric called Education Score is introduced to find the best-performing counties. It is defined as 80% of mean graduation percentage – 20% of mean dropout percentage across all cohorts. The top 10 counties are shown below.
Putnam County comes up with a mean graduation percentage of 94% and a mean dropout percentage of 2.9% leading to an Education Score of 74.62. We can also observe from the above plot that the top 10 counties have varying education scores from 75 to 72 indicating that many counties are performing as good as the top county. The graduation percentage of the top counties varies between 94% to 91% whereas the dropout% varies from 5% to 2% leading to an even performance score.
The educational analysis also arises the question of gender disparity within educational institutions. A quick look into the charts gives us a good overview of the recent percentage of male and the female populous in terms of enrolled, graduated, recent degree, recent advanced degree, dropout, still enrolled and local degree students in the state of New York.
Looking at the male population 35.5% are currently enrolled students, 29.7% are graduated students, 16.3% are regent degree holders and 11.9% are regent advance degree holders. Also, a low number is seen in terms of the dropout rate i.e. 2.73%.
Similarly with the female populous the number of graduated females is 31.2%, 15.1% are regent degree holders, 14.9% are advanced regent degree holders and only 1.61% are in the dropout count.
The above observations tell us that there is a higher percentage of female graduates and female graduate holding advanced degrees and have a lower dropout count.
Studies across different cohorts are available giving us an opportunity to investigate the participation across the English-learning population and the non- English learning population in the field of education according to the graduation percentage.
The wheel shows the percentage count of the English-learning population across different cohorts. Amongst the English-learning population the 2017 cohort- 4year outcome, indicated by the color ‘blue’ has the maximum graduation percentage as shown in the chart.
The wheel shows the percentage count of the Non-English learning population across different cohorts. Amongst the Non-English learning population, the 2016 cohort- 5-year outcome and 2015 cohort – 6-year outcome has the highest graduation percentage amongst others.
From the above, we can conclude that the overall graduation rate among English and Non-English learners in the field of education for the state has only slight variation.
The education system has been supportive of the disabled community helping them by providing the necessary arrangements in times of need. This assumption is put to test via the analysis conducted.
The above chart shows the graduation percentage across various counties
of all students in the state of New York. The counties of Nassau County
and Putnam County leads with a graduation percentage of 94% and is
followed by, Genesee County(93%) among others as shown above having a
varying graduation rate of 94% to 92%
Whereas the assumption might not be true. Although Putnam County comes in lead with the previous observation having the graduation percentage of 85% but falls overall with a low in Schoharie County the graduation percentage of 73% and an overall variation of 85% to 73%.
Although the system seems supportive of providing equal opportunities in the field of education further actions should be taken to improve the conditions in counties having low graduation percentage.
A study across the migrated Populous in the year 2020 vs the migrated Populous in the year 2021 is conducted to find and compare the participation level of both communities.
The above plot showcases the difference in enrollment numbers in Chautauqua County, Columbia County, Franklin County, Orange County, Saint Lawrence County, Suffolk County, and Sullivan County, in terms of enrollment count.
It can be observed that the enrollment counts his doing almost similar in some of the counties over the period of 2020 to 2021 whereas there has been a slight drop in numbers of Chautauqua County and Suffolk County.
To get an overview of the education parameter of different racial segments of the population to understand the understand how to better help them.
The analysis shows how the graduation percentage and dropout percentage vary across the State of New York with the Caucasian population having the highest graduation percentage of 87.47% followed by the Hispanic Populus(70.5%) and the African American Populus(67.4%).
It is also observed that the dropout percentage is led by the Hispanic Population with value of 10.3% followed by the African American Populus(8.6%), and multiracial Populus(6.7%) among others.
Economic Analysis is necessary for the revision of budget allocation among different counties, a comparative analysis is conducted considering the graduation percentage and dropout percentage between economically and non-Economically disadvantaged groups.
An even graduation percentage is seen for both the groups with the highest graduation rate in Genesee County for the economically challenged community(90%) and a variation from 90% to 86%; and Nassau and Putnam having similar high graduation rates for the non-economically challenged community(90%).
A wide disparity is seen in the dropout rate between the two communities with the economically challenged community having a variation of 14% to 2%, Essex County having the highest dropout percentage and the non-economically challenged community having a variation of 3% to 1%. We can conclude that a revised budget for the affected counties can be helpful in providing support in terms of education in affected areas.
The above analysis helps us observe the condition across various territories included through which we reach the conclusions as follows,
The counties having the highest population are among the counties also having the highest enrollment rate as assumed and bolstered by the Enrollment Comparison by County analysis and School Comparison by highest enrollment analysis respectively.
Good standardization is observed within the system as the counties show a close number in terms of education scores.
The female populous has higher percentage numbers in graduates and graduates holding advanced degrees with low dropout rates whereas the male populous is also doing well in terms of graduation and dropout percentage.
The overall participation among English and non-English speakers in the field of education is almost similar supporting the effectiveness of the system for people of different languages.
The system seems supportive of providing equal opportunities in the field of education, but further actions should be taken to support the diverse population while considering the African American and Hispanic populous.
The education system is also doing almost similar in many counties over the time of 2020 to 2021 with a slight rise in numbers in Chautauqua County and Suffolk County for the migrants supporting the effective systems in those areas.
Further analysis should be done to find the cause of the high dropout rate among multiracial communities while, proper funds allocation to ensure equal opportunities despite the economic gap.
• https://www.newyork-demographics.com/counties_by_population
• https://r-graph-gallery.com/
• https://www.data-to-viz.com/
• https://www.statology.org/r-plot-change-axis-scale/
• https://data.nysed.gov/downloads.php
• https://www.datamentor.io/r-programming/histogram/
• https://community.plotly.com/t/title-alignment-python/30820